// Mapper Interface with Annotations
package com.ruoyi.candidateType.mapper;

import com.ruoyi.candidateType.domain.ExamCandidateType;
import org.apache.ibatis.annotations.*;
import java.util.List;

@Mapper
public interface ExamCandidateTypeMapper {

    @Select("SELECT * FROM tb_candidate_type WHERE id = #{id}")
    ExamCandidateType selectCandidateTypeById(Long id);

    @Select("SELECT * FROM tb_candidate_type")
    List<ExamCandidateType> selectCandidateTypeList();

    @Insert("INSERT INTO tb_candidate_type (name) VALUES (#{name})")
    int insertCandidateType(ExamCandidateType candidateType);

    @Update("UPDATE tb_candidate_type SET name = #{name} WHERE id = #{id}")
    int updateCandidateType(ExamCandidateType candidateType);

    @Delete("DELETE FROM tb_candidate_type WHERE id IN (${ids})")
    int deleteCandidateTypeByIds(@Param("ids") String ids);
}